How to: Change the name of a field.
Solution:
To change a field name in the Table Design view, select the field name to be edited, and type a new field name.
To change a field name in the Table Datasheet view, select the field, and use the 'Rename Column' command under the 'Format' menu.
Do one of the following:
NOTE: If the Database window is not active, activate the Database window.
1) To change a field name in the Table Design view:
a) Make sure the table is opened in the Table Design view.
b) Click in the cell containing the desired field name in the 'Field Name' column.
c) Click and hold down the mouse button.
d) Run the cursor over the field name until the entire field name is highlighted.
e) Type a new field name.
f) Press ENTER.
g) Select the 'File' menu and select 'Save' to save the changes to the Design view.
NOTE: Changes in the Design view are NOT automatically saved by Access.
2) To change a field name in the Table Datasheet view:
a) Make sure the table is opened in the Table Datasheet view.
b) Select the field for which the name is to be edited:
1] Place the cursor over the 'Field Selector' for the desired field. (The cursor turns into a down arrow.)
Field Selector
2] Click mouse button. (The field is highlighted.)
c) Select the 'Format' menu and select 'Rename Column'. (The field name is highlighted.)
d) Type a new field name.
e) Press ENTER.
f) Select the 'File' menu and select 'Save Layout' to save the changes to the 'Datasheet' view
NOTE: Changes in the Datasheet view ARE saved automatically by Access.
